﻿CREATE TABLE [dbo].[book] (
    [id]                  INT  NOT NULL,
    [title]               TEXT NULL,
    [author_id]           INT  NOT NULL,
    [category_id]         INT  NOT NULL,
    [publishing_house_id] INT  NOT NULL,
    [Count]               INT  NULL,
    CONSTRAINT [PK_book] PRIMARY KEY CLUSTERED ([id] ASC),
    CONSTRAINT [FK_book_publishing_house] FOREIGN KEY ([publishing_house_id]) REFERENCES [dbo].[publishing_house] ([id])
);

